Utilities 313

Of note, the switch between CleanChoice and Pepco. It makes Feb 2021 unusually low, and June 2023 unusually high.

Go to Home Page
  • Total Spending per Month
  • Spend per Category per Month
  • Amount per Person
  • Individual Expenses
  • Tables
  • Treemap of Categories

Mobile users!
Landscape mode is your friend

Summary

Total Amount spent: $20,230.16

Total Amount per Person: $6,743.39

Date Range: November 2020 - February 2025

Data Assumptions¶

As part of the process of switching between electric companies, June of 2023 charged an unusally high amount after shortchanging the prior month. In a few short plots, I will move some of that money from June to May of 2023, at this point in the analysis, to more accurately reflect what billing should have been.

At the same point, I will consolidate "Pepco" and "CleanChoice" into one creatively-named value, "Electric". Accounting wizardry.

In the spirit of data assumptions, I manually updated December 2023 through April 2024, to account for the weird stretch where the utility company only billed $19/month and created a giant backlog of debt that had to be paid off.

Some days, you're just on hold with the Electric company.

Total Spending per Month¶


Back to Top



Bill per Category per Month¶


Back to Top

This is the only time you'll see the Pepco / CleanChoice data. After this, they'll be consolidated into "Electric"

Data Change¶

Here is where I consolidate CleanChoice and Pepco into "Electric". I also pull a sneaky trick and move $143.50 from June 2023 to May 2023. See intro.




Bill per Person¶


Back to Top



Out[18]:
Amount Amount_per_person
count 52.000000 52.000000
mean 389.041538 129.680513
std 79.642766 26.547589
min 194.000000 64.666667
25% 339.865000 113.288333
50% 390.305000 130.101667
75% 425.167500 141.722500
max 579.930000 193.310000




Individual Expenses¶


Back to Top





Tables¶


Back to Top



Treemap of Categories¶


Back to Top